{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["FilingGuide","Cover Pages 1-2","Cover Page 3","Report Pages 1-8","SurchargeInformation","Data"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":2,"defined_names":6,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"FilingGuide","index":0,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Cover Pages 1-2","index":1,"n_rows":70,"n_cols":10,"rows_kept":70,"cut":false,"hidden":false,"merged":[[63,1,63,9],[65,1,65,9],[67,1,67,9],[69,1,70,9],[74,0,74,8],[73,0,73,8],[26,0,26,8],[29,0,29,8],[31,0,31,8],[33,5,33,6],[41,0,41,9],[17,1,17,2],[17,4,17,8],[20,1,20,2],[20,4,20,6],[23,0,23,8],[5,1,5,2],[5,4,5,5],[7,0,7,8],[11,1,11,2],[14,1,14,2],[9,1,9,7],[11,4,11,8],[14,4,14,5],[12,4,12,8],[59,1,59,7],[61,1,61,9],[36,0,36,8],[45,0,45,9],[47,1,47,7],[49,1,49,9],[53,1,53,9],[55,1,55,9],[57,1,57,9],[42,5,42,6],[51,1,51,10]]}
[]
[null,null,null,null,null,null,null,null,null,"NARUC Class C"]
[null,null,null,null,null,null,null,null,null,"Privately Owned"]
[]
[]
[null,"Docket No.:",null,null,"23-01003"]
[]
["ANNUAL REPORT"]
[]
[null,"OF"]
[]
[null,"Company Name:"]
[null,null,null,null,"(Legal Name of Utility)"]
[]
[null,"CPC Number(s):"]
[]
[]
[null,"Principal Office Address:"]
[]
[]
[null,"For the Period Ending:",null,null,"   December 31,",null,null,2022]
[]
[]
["COMBINED WATER AND WASTEWATER UTILITY"]
[]
[]
["TO THE"]
[]
[]
["PUBLIC UTILITIES COMMISSION"]
[]
["OF NEVADA"]
[]
[null,null,null,null,"Date of filing:"]
[]
[]
[{"$f":"CONCATENATE(\"Due by May 15, \",H21+1)","v":"Due by May 15, 2023"}]
[]
[null,null,null,null,"Check one:"]
[null,null,null,null,null,"Original Submission"]
[null,null,null,null,null,"Corrected Submission*"]
["* If the original filing is being amended or corrected, the entire report must be resubmitted."]
[null,null,null,null,"Corrected Filing Date:"]
[]
[]
["GENERAL GUIDELINES FOR REPORTING"]
[]
["1.","This form is formatted using Microsoft Excel to allow for electronic preparation.   "]
[]
[2,"In the data areas on the following pages, please input the requested information in the gray highlighted areas.  The spreadsheet has been programmed to perform all the necessary calculations.  Non-highlighted areas are locked and cannot be accessed by the user."]
[]
[3,"Enter whole dollar amounts only.  Round cents up or down to the nearest whole dollar."]
[]
[4,"If the amount to be input into a normally positive data field is negative, then precede the amount with a negative sign (-)."]
[]
[5,"If the amount to be input is zero, then input a zero; Excel will display a hyphen in the cell.  Do not input \na hyphen."]
[]
[6,"The annual report should be fully completed.  References to returns of former years or to other reports should not take the place of required entries except as specifically instructed by the PUCN."]
[]
[7,"Where information called for is not provided, explain the reason for its omission. "]
[]
[8,"If it is necessary or desirable to show additional statements or schedules for the purpose of further explanation, they should be made on standard letter-size paper.  Each additional supporting schedule should contain the page and line reference to the PUCN form so that PUCN staff will be able to follow the preparer's intentions."]
[]
[9,"Wherever schedules call for comparisons to figures of a previous year, the figures reported must be based upon those shown on this company's annual report from the previous year or an appropriate explanation given as to why different figures were used."]
[null,"      "]
[10,"The Nevada Administrative Code 704.628(6) requires that the books and records maintained by the utility must comply with the systems of accounts established for water/wastewater utilities prepared by the National Association of Regulatory Commissioners (NARUC).  The account numbers listed in the accompanying annual report are NARUC account numbers.  If the company uses a different account numbering system, please attach an explanation along with a cross-reference from the company's account numbers to the NARUC account numbers."]
[null,"      "]
[11,"If the utility collects and maintains a Commission-approved surcharge to fund system improvements, complete the supplemental surcharge information schedules located at the end of this report.  Remember to include a copy of the year-end bank statement for the surcharge account as requested on the form."]
[]
[12,"When printing this form, print each tab separately for correct pagination.  Do NOT print the entire workbook."]

{"sheet":"Cover Page 3","index":2,"n_rows":41,"n_cols":14,"rows_kept":41,"cut":false,"hidden":false,"merged":[[29,7,29,11],[26,10,26,11],[24,10,24,11],[25,10,25,11],[21,4,21,8],[27,10,27,11],[25,3,25,8],[26,3,26,8],[27,3,27,8],[47,0,47,12],[31,1,31,11],[40,1,40,11],[34,2,34,8],[32,2,32,8],[33,2,33,8],[36,2,36,8],[37,2,37,8],[38,2,38,8],[35,2,35,8],[41,1,44,11],[0,0,0,11],[2,0,2,11],[3,0,3,11],[4,0,4,11],[12,2,12,10],[6,0,6,11],[10,2,10,10],[13,2,13,6],[15,4,15,6],[17,7,17,8],[20,2,20,8],[24,3,24,8]]}
["PUBLIC UTILITIES COMMISSION OF NEVADA"]
[]
["COMBINED WATER AND WASTEWATER UTILITY ANNUAL REPORT"]
["Class C"]
["(Annual Revenues of less than $200,000)"]
[]
["(Do not exceed the length of the highlighted cells)"]
[]
[1,{"$f":"CONCATENATE(\"For the Period Ending:    December 31, \",'Cover Pages 1-2'!H21)","v":"For the Period Ending:    December 31, 2022"},null,null,null,null,null,null,null,null,null,null,null,2006]
[]
[2,{"$f":"CONCATENATE(\"Report of:   \",'Cover Pages 1-2'!E12)","v":"Report of:   "}]
[]
[3,"Address:"]
[null,"     City:  ",null,null,null,null,null,null,"State:",null,"Zip Code:"]
[]
[4,"Telephone number:"]
[]
[5,"Date of original organization of utility:"]
[]
[6,"Person to whom correspondence should be addressed concerning this report:"]
[null,"      Name:"]
[null,"      Telephone No.:"]
[]
[7,"Utility officers:"]
[null,"      President:",null,null,null,null,null,null,null,"Telephone No."]
[null,"      Vice-Pres.",null,null,null,null,null,null,null,"Telephone No."]
[null,"      Treasurer:",null,null,null,null,null,null,null,"Telephone No."]
[null,"      Secretary:",null,null,null,null,null,null,null,"Telephone No."]
[]
[8,"What public services are rendered?"]
[]
[9,"If a corporation - Provide the Name and Percentage of each person owning or holding directly or indirectly five (5) percent or more of the voting securities of this company:"]
[null,"      Name:",null,null,null,null,null,null,null,"Percent:  "]
[null,"      Name:",null,null,null,null,null,null,null,"Percent:  "]
[null,"      Name:",null,null,null,null,null,null,null,"Percent:  "]
[null,"      Name:",null,null,null,null,null,null,null,"Percent:  "]
[null,"      Name:",null,null,null,null,null,null,null,"Percent:  "]
[null,"      Name:",null,null,null,null,null,null,null,"Percent:  "]
[null,"      Name:",null,null,null,null,null,null,null,"Percent:  "]
[]
[10,"Give a brief description of major transactions which have occurred during the year which will have material effect on operations, such as rate changes, or changes in plant or operating practices.  Provide any additional information or other explanations that are needed in order for the reader to understand what is in the report, attaching additional pages if necessary:"]

{"sheet":"Report Pages 1-8","index":3,"n_rows":542,"n_cols":8,"rows_kept":542,"cut":false,"hidden":false,"merged":[[545,1,545,2],[505,3,505,6],[1,0,1,7],[277,0,277,7],[278,0,278,7],[140,1,140,3],[208,0,208,7],[209,1,209,3],[139,0,139,7],[43,0,43,7],[67,0,67,7],[46,1,46,3],[3,1,3,3],[2,1,2,3],[141,1,141,3],[4,1,4,2],[21,1,21,2],[47,1,47,2],[142,1,142,2],[521,1,521,2],[395,0,395,7],[345,0,345,7],[211,1,211,2],[174,1,174,2],[68,1,68,3],[106,1,106,2],[113,1,113,2],[92,1,92,2],[99,1,99,2],[70,1,70,3],[413,0,413,7],[414,1,414,3],[346,0,346,7],[279,1,279,3],[280,1,280,3],[210,1,210,3],[242,1,242,2],[281,1,281,2],[292,1,292,2],[299,1,299,2],[308,1,308,2],[274,0,274,2],[274,3,274,5],[274,6,274,7],[343,0,343,2],[343,3,343,5],[343,6,343,7],[347,1,347,3],[485,2,485,6],[487,1,487,6],[507,3,507,6],[509,3,509,6],[349,1,349,2],[357,1,357,2],[370,1,370,2],[376,1,376,2],[348,1,348,3],[482,0,482,6],[415,1,415,3],[444,0,444,7],[417,1,417,2],[429,1,429,2],[434,1,434,2],[137,6,137,7],[45,1,45,3],[206,0,206,2],[206,3,206,5],[206,6,206,7],[65,6,65,7],[65,3,65,5],[65,0,65,2],[82,1,82,3],[137,0,137,2],[137,3,137,5],[541,0,541,2],[541,3,541,5],[541,6,541,7],[530,1,530,2],[411,0,411,2],[411,3,411,5],[411,6,411,7],[477,0,477,2],[477,3,477,5],[477,6,477,7],[514,3,514,6],[506,3,506,7],[510,3,510,7],[511,3,511,7]]}
[{"$f":"CONCATENATE(\"Annual Report of:    \",'Cover Pages 1-2'!$E$12)","v":"Annual Report of:    "},null,null,null,null,null,null,{"$f":"CONCATENATE(\"For the Period Ending:    December 31, \",'Cover Pages 1-2'!$H$21)","v":"For the Period Ending:    December 31, 2022"}]
["INCOME AND RETAINED EARNINGS STATEMENT- TOTAL COMPANY"]
[null,"(a)",null,null,null,"(b)","(c) ","(d)"]
["Line  No.","Descriptions",null,null,"NARUC Water Account Number","This Year                 $","Last Year                          $","Increase or (Decrease)"]
[null,"UTILITY OPERATING INCOME"]
[1,"Operating Revenues                           ",null,"Line 37, Col. (b)",400,{"$f":"F49","v":0},0,{"$f":"+F6-G6","v":0}]
[{"$f":"1+A6","v":2}]
[{"$f":"1+A7","v":3},"Operating Expense                            ",null,"Line 39, Col. (b)",401,{"$f":"F51","v":0},0,{"$f":"+F8-G8","v":0}]
["4a","Depreciation Expense                          ",null,"Line 40a, Col. (b)",403,{"$f":"F52","v":0},0,{"$f":"+F9-G9","v":0}]
["4b","CIAC Amort. Expense - CR. * ",null,"Line 40b, Col. (b)",403,{"$f":"F53","v":0},0,0]
[5,"Amort.- Utility Plant Acquisition Adjustment",null,"Line 41, Col. (b)",406,{"$f":"F54","v":0},0,0]
[6,"Amortization Expense - Other **",null,"Line 42, Col. (b)",407,0,0,0]
[7,"Taxes other than Income Taxes",null,"Line 43, Col. (b)",408,0,0,0]
[8,"Federal Income Tax ",null,"Line 44, Col. (b)",409,0,0,0]
[9,"Provision for Deferred Income Taxes - DR.",null,"Line 45, Col. (b)",410,0,0,0]
[10,"Provision for Deferred Income Taxes - CR. *",null,"Line 46, Col. (b)",411,0,0,0]
[11,"Investment Tax Credits - CR. *",null,"Line 47, Col. (b)",412,0,0,0]
[12,"               Total Operating Expenses   ",null,null,null,{"$f":"SUM(F8:F17)","v":0},{"$f":"SUM(G8:G17)","v":0},{"$f":"SUM(H8:H17)","v":0}]
[13]
[{"$f":"1+A19","v":14},"Net Operating Income                                                   (Line 1 -  Line 12)",null,null,null,{"$f":"+F6-F18","v":0},{"$f":"+G6-G18","v":0},{"$f":"+H6-H18","v":0}]
[15]
[16,"OTHER INCOME and DEDUCTIONS"]
[17,"Interest & Dividend Income",null,null,419,0,0,{"$f":"+F23-G23","v":0}]
[18,"Allowance for Funds Used During Construction",null,null,420,0,0,0]
[19,"Non-Utility Income",null,null,421,0,0,0]
[20,"Less:  Miscellaneous Non-Utility Expense * and **",null,null,426,0,0,0]
[21,"Interest Expense *",null,null,427,0,0,0]
[22,"Taxes Applicable to Other Income & Deductions",null,null,"408-412",0,0,0]
[23,"            Total Other Income & Deductions",null,null,null,{"$f":"SUM(F23:F28)","v":0},{"$f":"SUM(G23:G28)","v":0},{"$f":"SUM(H23:H28)","v":0}]
[24]
[25,"Net Income                       (Line 14 + Line 23)                         (to Line 30)",null,null,null,{"$f":"+F20+F29","v":0},{"$f":"+G20+G29","v":0},{"$f":"+H20+H29","v":0}]
[26]
[27]
[28,"Retained Earnings   (Corporations ONLY)",null,null,215]
[29,"Retained Earnings   (beginning)                          (from \"Last Year\" col.)",null,null,null,{"$f":"+G42","v":0},0,{"$f":"+F35-G35","v":0}]
[30,"Balance Transferred from Net Income                (from Line 25)",null,null,null,{"$f":"+F31","v":0},{"$f":"+G31","v":0},0]
[31,null,null,null,null,0,0,0]
[32,null,null,null,null,0,0,0]
[33,"Dividends Declared - Common Stock *",null,null,null,0,0,0]
[34,"Adjustments to Retained Earnings **",null,null,null,0,0,0]
[35]
[36,"Retained Earnings (ending)                                (to Page 9, Line 4)",null,null,215,{"$f":"SUM(F35:F40)","v":0},{"$f":"SUM(G35:G40)","v":0},{"$f":"SUM(H35:H40)","v":0}]
[]
["NET OPERATING INCOME BY DEPARTMENT"]
[]
[null,"(a)",null,null,null,"(b)","(c) ","(d)"]
["Line  No.","Descriptions",null,null,"NARUC Water Account Number","Total Company              $","Water                          $","Wastewater                               $"]
[null,"UTILITY OPERATING INCOME"]
[37,"Operating Revenues    (from Page 6, Line 27, Col. (b) & Page 7, Line 26, Col. (b))",null,null,400,{"$f":"SUM(G49:H49)","v":0},{"$f":"F171","v":0},{"$f":"F239","v":0}]
[38]
[39,"Operating Expense         (from Page 6, Line 49, Col. (b) & Page 7, Line 51, Col. (b))",null,null,401,{"$f":"SUM(G51:H51)","v":0},{"$f":"F195","v":0},{"$f":"F264","v":0}]
["40a","Depreciation Expense    (from Page 5, Line 8, Col. (c) & Line 20, Col. (c))",null,null,403,{"$f":"SUM(G52:H52)","v":0},{"$f":"G78","v":0},{"$f":"G90","v":0}]
["40b","CIAC Amortization - CR. *",null,null,403,{"$f":"SUM(G53:H53)","v":0},0,0]
[41,"Amortization Of Utility Plant Acquisition Adjustment",null,null,406,{"$f":"SUM(G54:H54)","v":0},0,0]
[{"$f":"1+A54","v":42},"Amortization Expense - Other **",null,null,407,0,0,0]
[43,"Taxes other than Income Taxes",null,null,408,0,0,0]
[44,"Federal Income Tax ",null,null,409,0,0,0]
[45,"Provision for Deferred Income Taxes - DR.",null,null,410,0,0,0]
[46,"Provision for Deferred Income Taxes - CR. *",null,null,411,0,0,0]
[47,"Investment Tax Credits - CR. *",null,null,412,0,0,0]
[48,"               Total Operating Expenses   ",null,null,null,{"$f":"SUM(F51:F60)","v":0},{"$f":"SUM(G51:G60)","v":0},{"$f":"SUM(H51:H60)","v":0}]
[49]
[50,"Net Operating Income                                              (Line 37 -  Line 48)",null,null,null,{"$f":"+F49-F61","v":0},{"$f":"+G49-G61","v":0},{"$f":"+H49-H61","v":0}]
[null,"* Amount should be entered as NEGATIVE."]
[null,"** If over $2,000, attach detailed supporting schedule."]
["Docket No. 23-01003\nWater/Wastewater Combined - Class C",null,null,"Page 4 of 13",null,null,"Revised January 2023"]
[{"$f":"CONCATENATE(\"Annual Report of:    \",'Cover Pages 1-2'!$E$12)","v":"Annual Report of:    "},null,null,null,null,null,null,{"$f":"CONCATENATE(\"For the Period Ending:    December 31, \",'Cover Pages 1-2'!$H$21)","v":"For the Period Ending:    December 31, 2022"}]
["DEPRECIATION RATES BY MAJOR PLANT CATEGORY"]
[null,"(a)",null,null,null,"(b)","(c) ","(d)"]
[null,null,null,null,null,null,null,"Weighted Ave."]
[1,"Water:",null,null,null,"Water Plant","Annual Depr.  Exp.","Annual Depr. %"]
[{"$f":"A71+1","v":2},"Intangible Plant                                     (Plant Accts. 301 - 303)",null,null,null,0,0,{"$f":"IF(+G72=0,0,G72/F72)","v":0}]
[{"$f":"A72+1","v":3},"Source of Supply plant                         (Plant Accts. 304 - 309)",null,null,null,0,0,0]
[4,"Pumping plant                                       (Plant Accts. 310 - 311)",null,null,null,0,0,0]
[5,"Water Treatment plant                          (Plant Accts. 320)",null,null,null,0,0,0]
[6,"Transmission & Distribution plant       (Plant Accts. 330 - 339)",null,null,null,0,0,0]
[7,"General plant                                         (Plant Accts. 340 - 348)",null,null,null,0,0,0]
[8,"          Water Totals ",null,null,null,{"$f":"SUM(F72:F77)","v":0},{"$f":"SUM(G72:G77)","v":0}]
[9,null,null,null,null,null,"to Page 4, Line 40a, Col. (c)"]
[10]
[11]
[12,null,null,null,null,null,null,"Weighted Ave."]
[13,"Wastewater:",null,null,null,"Wastewater Plant","Annual Depr.  Exp.","Annual Depr. %"]
[14,"Intangible Plant                                (Plant Accts. 351 - 353)",null,null,null,0,0,{"$f":"IF(+G84=0,0,G84/F84)","v":0}]
[15,"Structures & Improvements             (Plant Accts. 354 - 355)",null,null,null,0,0,0]
[16,"Collection System                            (Plant Accts. 360 - 365)",null,null,null,0,0,0]
[17,"Receiving Wells                               (Plant Acct.  370)",null,null,null,0,0,0]
[18,"Treatment & Disposal                      (Plant Accts. 380 - 389)",null,null,null,0,0,0]
[19,"General plant                                    (Plant Accts. 390 - 398)",null,null,null,0,0,0]
[20,"          Wastewater Totals  ",null,null,null,{"$f":"SUM(F84:F89)","v":0},{"$f":"SUM(G84:G89)","v":0}]
[null,null,null,null,null,null,"to Page 4, Line 40a, Col. (d)"]
[]
[21,"UTILITY PLANT AND DEPRECIATION",null,null,null,"Total ","Water ","Wastewater"]
[{"$f":"1+A93","v":22},"PLANT:",null,null,null,"Utility","Utility","Utility "]
[{"$f":"1+A94","v":23},"Balance Beginning of Current Year",null,null,null,{"$f":"G95+H95","v":0},0,0]
[{"$f":"1+A95","v":24},"Additions:                                                 (Plant added during the year)",null,null,null,{"$f":"SUM(G96:H96)","v":0},0,0]
[{"$f":"1+A96","v":25},"Retirements / Deletions: - CR. *              (Plant removed during the year)",null,null,null,{"$f":"SUM(G97:H97)","v":0},0,0]
[{"$f":"1+A97","v":26},"Balance End of Current Year              (to Page 8, Line 1)",null,null,null,{"$f":"+F95+F96+F97","v":0},{"$f":"SUM(G95:G97)","v":0},{"$f":"SUM(H95:H97)","v":0}]
[]
[27,"ACCUMULATED DEPRECIATION:"]
[{"$f":"1+A100","v":28},"Balance Beginning of Current Year",null,null,null,{"$f":"SUM(G101:H101)","v":0},0,0]
[{"$f":"1+A101","v":29},"Additions:       (Depreciation expense from Line 8, Col. (c) & Line 20, Col. (c))",null,null,null,{"$f":"SUM(G102:H102)","v":0},{"$f":"G78","v":0},{"$f":"G90","v":0}]
[{"$f":"1+A102","v":30},"Retirements / Deletions: - CR. *          (Plant removed during the year)",null,null,null,{"$f":"SUM(G103:H103)","v":0},0,0]
[{"$f":"1+A103","v":31},"Balance End of Current Year          (to Page 8, Line 2)",null,null,null,{"$f":"+F101+F102+F103","v":0},{"$f":"SUM(G101:G103)","v":0},{"$f":"SUM(H101:H103)","v":0}]
[]
[]
[32,"UTILITY CIAC AND AMORTIZATION",null,null,null,"Total ","Water ","Wastewater"]
[{"$f":"1+A107","v":33},"CONTRIBUTIONS IN AID OF CONSTRUCTION:",null,null,null,"Utility","Utility","Utility "]
[34,"Balance Beginning of Current Year",null,null,null,{"$f":"G109+H109","v":0},0,0]
[35,"Additions:                                                 (CIAC added during the year)",null,null,null,{"$f":"SUM(G110:H110)","v":0},0,0]
[36,"Retirements / Deletions: - CR. *               (CIAC removed during the year)",null,null,null,{"$f":"SUM(G111:H111)","v":0},0,0]
[37,"Balance End of Current Year               (to Page 9, Line 32)",null,null,null,{"$f":"+F109+F110+F111","v":0},{"$f":"SUM(G109:G111)","v":0},{"$f":"SUM(H109:H111)","v":0}]
[38]
[39,"ACCUMULATED AMORTIZATION:"]
[40,"Balance Beginning of Current Year",null,null,null,{"$f":"SUM(G115:H115)","v":0},0,0]
[41,"Additions:             (Amortization from Page 4, Line 40b, Col. (c) & Col. (d))",null,null,null,{"$f":"SUM(G116:H116)","v":0},{"$f":"-G53","v":0},{"$f":"-H53","v":0}]
[42,"Retirements / Deletions: - CR. *        (CIAC removed during the year)",null,null,null,{"$f":"SUM(G117:H117)","v":0},0,0]
[43,"Balance End of Current Year         (to Page 9, Line 33)",null,null,null,{"$f":"+F115+F116+F117","v":0},{"$f":"SUM(G115:G117)","v":0},{"$f":"SUM(H115:H117)","v":0}]
[null,"* Amount should be entered as NEGATIVE."]
[null,"** If over $2,000, attach detailed supporting schedule."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Docket No. 23-01003\nWater/Wastewater Combined - Class C",null,null,"Page 5 of 13",null,null,"Revised January 2023"]
[{"$f":"CONCATENATE(\"Annual Report of:    \",'Cover Pages 1-2'!$E$12)","v":"Annual Report of:    "},null,null,null,null,null,null,{"$f":"CONCATENATE(\"For the Period Ending:    December 31, \",'Cover Pages 1-2'!$H$21)","v":"For the Period Ending:    December 31, 2022"}]
["WATER OPERATING REVENUES AND EXPENSES"]
[null,"(a)",null,null,null,"( b )","( c ) ","( d )"]
["Line  No.","Description",null,null,"NARUC Water Account Number","Dollar           Amount","Total                 Year-End Customers","Gallons of Water Sold Metered & Unmetered *"]
[null,"OPERATING REVENUES ",null,null,null,null,null,"(in Thousands)"]
[null,"REVENUE FROM WATER SALES:  ",null,null,400]
[1,"Unmetered Water Revenues:"]
[{"$f":"1+A145","v":2},"             Residential Customers",null,null,460.1,0,0,0]
[{"$f":"1+A146","v":3},"             Commercial Customers",null,null,460.2,0,0,0]
[4,"             Industrial Customers",null,null,460.3,0,0,0]
[5,"             Public Authorities",null,null,460.4,0,0,0]
[6,"             Multiple Family Dwellings",null,null,460.5,0,0,0]
[7,"             Other **",null,null,460.6,0,0,0]
[8,"                  Total Unmetered Sales",null,null,null,{"$f":"SUM(F146:F151)","v":0},{"$f":"SUM(G146:G151)","v":0},{"$f":"SUM(H146:H151)","v":0}]
[9,"Metered Water Revenues:"]
[10,"              Residential Customers",null,null,461.1,0,0,0]
[11,"              Commercial Customers",null,null,461.2,0,0,0]
[12,"              Industrial Customers",null,null,461.3,0,0,0]
[13,"              Public Authorities",null,null,461.4,0,0,0]
[14,"              Multiple Family Dwellings",null,null,461.5,0,0,0]
[15,"                   Total Metered Sales",null,null,null,{"$f":"SUM(F154:F158)","v":0},{"$f":"SUM(G154:G158)","v":0},{"$f":"SUM(H154:H158)","v":0}]
[16]
[17,"Fire-Protection Revenue",null,null,462,0,0,0]
[18,"Sales to Irrigation Customers ",null,null,465,0,0,0]
[19,"Sales for Resale ",null,null,466,0,0,0]
[20,"                    Total Sales of Water         ",null,null,null,{"$f":"SUM(F161:F163)+F152+F159","v":0},{"$f":"SUM(G161:G163)+G152+G159","v":0},{"$f":"SUM(H161:H163)+H152+H159","v":0}]
[21,"         * When customer meters record in cubic feet, multiply by 7.45 to obtain number of gallons."]
[22,"OTHER WATER REVENUES:"]
[23,"Guaranteed Revenues",null,null,469,0]
[24,"Other Water Revenues **",null,null,474,0]
[25,"                      Total Other Water Revenues",null,null,null,{"$f":"SUM(F167:F168)","v":0}]
[26]
[27,"           Total Water Operating Revenues      (to Page 4, Line 37, Col. (c))",null,null,400,{"$f":"+F164+F169","v":0}]
[28,{"$f":"+IF(F171>=200000,\"             ERROR - Total Operating Revenue exceeds $200,000, Please use 'Class B Annual Report.'\",\" \")","v":" "}]
[29]
[30,null,null,null,null,"This Year                           $","Last Year                        $","Increase or (Decrease)"]
[31,"OPERATING EXPENSES",null,null,401]
[32,"Salaries & Wages - Employees",null,null,601,0,0,{"$f":"+F176-G176","v":0}]
[33,"Salaries & Wages - Officers, Directors & Major Stkhldrs",null,null,603,0,0,{"$f":"+F177-G177","v":0}]
[34,"Employee Pensions & Benefits",null,null,604,0,0,0]
[35,"Purchased Water",null,null,610,0,0,0]
[36,"Purchased Power",null,null,615,0,0,0]
[37,"Fuel for Power Production",null,null,616,0,0,0]
[38,"Chemicals",null,null,618,0,0,0]
[39,"Material and Supplies",null,null,620,0,0,0]
[40,"Contractual Services - Billing",null,null,630,0,0,0]
[41,"Contractual Services - Professional",null,null,631,0,0,0]
[42,"Contractual Services - Testing",null,null,635,0,0,0]
[43,"Contractual Services - Other **",null,null,636,0,0,0]
[44,"Rents",null,null,640,0,0,0]
[45,"Transportation Expense",null,null,650,0,0,0]
[46,"Insurance Expense",null,null,655,0,0,0]
[47,"Regulatory Commission Expense",null,null,665,0,0,0]
[48,"Bad Debt Expense",null,null,670,0,0,0]
[49,"Miscellaneous Expense **",null,null,675,0,0,0]
[50]
[51,"      Total Water Operating Expenses      ",null,null,401,{"$f":"SUM(F176:F193)","v":0},{"$f":"SUM(G176:G193)","v":0},{"$f":"SUM(H176:H193)","v":0}]
[null,"** If over $2,000, attach detailed supporting schedule.",null,null,null,"to Page 4, Line 39, Col. (c)"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Docket No. 23-01003\nWater/Wastewater Combined - Class C",null,null,"Page 6 of 13",null,null,"Revised January 2023"]
[{"$f":"CONCATENATE(\"Annual Report of:    \",'Cover Pages 1-2'!$E$12)","v":"Annual Report of:    "},null,null,null,null,null,null,{"$f":"CONCATENATE(\"For the Period Ending:    December 31, \",'Cover Pages 1-2'!$H$21)","v":"For the Period Ending:    December 31, 2022"}]
["WASTEWATER OPERATING REVENUES AND EXPENSES"]
[null,"(a)",null,null,null,"( b )","( c ) ","( d )"]
["Line  No.","Descriptions ",null,null,"NARUC Waste-water Account Number","Dollar          Amount","Total                 Year-End Customers","Gallons of Effluent Collected Metered & Unmetered "]
[null,"OPERATING REVENUES ",null,null,null,null,null,"(in Thousands)"]
[null,"REVENUE FROM WASTEWATER SALES:",null,null,400]
[1,"Flat Rate Revenues:"]
[{"$f":"1+A214","v":2},"             Residential ",null,null,521.1,0,0,0]
[{"$f":"1+A215","v":3},"             Commercial",null,null,521.20000000000005,0,0,0]
[4,"             Industrial ",null,null,521.29999999999995,0,0,0]
[5,"             Public Authorities",null,null,521.4,0,0,0]
[6,"             Multiple Family Dwellings",null,null,521.5,0,0,0]
[7,"             Other **",null,null,521.6,0,0,0]
[8,"                  Total Flat Rate Revenues",null,null,null,{"$f":"SUM(F215:F220)","v":0},{"$f":"SUM(G215:G220)","v":0},{"$f":"SUM(H215:H220)","v":0}]
[9]
[10,"Measured Revenues:"]
[11,"             Residential",null,null,522.1,0,0,0]
[12,"             Commercial",null,null,522.20000000000005,0,0,0]
[13,"             Industrial",null,null,522.29999999999995,0,0,0]
[14,"             Public Authorities",null,null,522.4,0,0,0]
[15,"             Multiple Family Dwellings",null,null,522.5,0,0,0]
[16,"                   Total Measured Revenues",null,null,null,{"$f":"SUM(F224:F228)","v":0},{"$f":"SUM(G224:G228)","v":0},{"$f":"SUM(H224:H228)","v":0}]
[17]
[18,"Revenues from Other Systems **",null,null,524,0,0,0]
[19,"                    Total Sales of Wastewater",null,null,null,{"$f":"+F221+F229+F231","v":0},{"$f":"+G221+G229+G231","v":0},{"$f":"+H221+H229+H231","v":0}]
[20]
[21,"OTHER WASTEWATER REVENUES:"]
[22,"Guaranteed Revenues",null,null,530,0]
[23,"Other Wastewater Revenues **",null,null,536,0]
[24,"                    Total Other Wastewater Revenues",null,null,null,{"$f":"SUM(F235:F236)","v":0}]
[25]
[26,"           Total Wastewater Operating Revenues   (to Page 4, Line 37, Col. (d))",null,null,400,{"$f":"+F232+F237","v":0}]
[27,{"$f":"+IF(F239>=200000,\"             ERROR - Total Operating Revenue exceeds $200,000, Please use 'Class B Annual Report.'\",\" \")","v":" "}]
[28]
[29,null,null,null,null,"This Year                         $","Last Year                       $","Increase or (Decrease)"]
[30,"OPERATING EXPENSES",null,null,401]
[31,"Salaries & Wages - Employees",null,null,701,0,0,{"$f":"+F244-G244","v":0}]
[32,"Salaries & Wages - Officers, Directors & Major Stkhldrs",null,null,703,0,0,{"$f":"+F245-G245","v":0}]
[33,"Employee Pensions & Benefits",null,null,704,0,0,0]
[34,"Purchased Wastewater Treatment",null,null,710,0,0,0]
[35,"Sludge Removal Expense",null,null,711,0,0,0]
[36,"Purchased Power",null,null,715,0,0,0]
[37,"Fuel for Power Production",null,null,716,0,0,0]
[38,"Chemicals",null,null,718,0,0,0]
[39,"Material and Supplies",null,null,720,0,0,0]
[40,"Contractual Services - Billing",null,null,730,0,0,0]
[41,"Contractual Services - Professional",null,null,731,0,0,0]
[42,"Contractual Services - Testing",null,null,735,0,0,0]
[43,"Contractual Services - Other **",null,null,736,0,0,0]
[44,"Rents",null,null,740,0,0,0]
[45,"Transportation Expense",null,null,750,0,0,0]
[46,"Insurance Expense",null,null,755,0,0,0]
[47,"Regulatory Commission Expense",null,null,765,0,0,0]
[48,"Bad Debt Expense",null,null,770,0,0,0]
[49,"Miscellaneous Expense **",null,null,775,0,0,0]
[50]
[51,"      Total Wastewater Operating Expenses     ",null,null,401,{"$f":"SUM(F244:F262)","v":0},{"$f":"SUM(G244:G262)","v":0},{"$f":"SUM(H244:H262)","v":0}]
[null,"** If over $2,000, attach detailed supporting schedule.",null,null,null,"to Page 4, Line 39, Col. (d)"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Docket No. 23-01003\nWater/Wastewater Combined - Class C",null,null,"Page 7 of 13",null,null,"Revised January 2023"]
[]
[{"$f":"CONCATENATE(\"Annual Report of:    \",'Cover Pages 1-2'!$E$12)","v":"Annual Report of:    "},null,null,null,null,null,null,{"$f":"CONCATENATE(\"For the Period Ending:    December 31, \",'Cover Pages 1-2'!$H$21)","v":"For the Period Ending:    December 31, 2022"}]
["BALANCE SHEET - TOTAL COMPANY"]
["(Assets and Other Debits)"]
[null,"(a)",null,null,null,"(b)","(c)","(d)"]
["Line  No.","Descriptions",null,null,"NARUC Account Number","This Year                   $","Last Year                         $","Increase or (Decrease)"]
[null,"UTILITY PLANT"]
[1,"Utility Plant               (from Page 5, Line 23, Col. (b) & Line 26, Col. (b))",null,null,101,{"$f":"+F98","v":0},{"$f":"F95","v":0},{"$f":"+F283-G283","v":0}]
[{"$f":"1+A283","v":2},"Less:  Accum. Dep.       (from Page 5, Line 28, Col. (b) & Line 31, Col. (b))",null,null,108,{"$f":"-F104","v":0},{"$f":"-F101","v":0},{"$f":"+F284-G284","v":0}]
[{"$f":"1+A284","v":3},"          Net Utility Plant",null,null,null,{"$f":"SUM(F283:F284)","v":0},{"$f":"SUM(G283:G284)","v":0},{"$f":"SUM(H283:H284)","v":0}]
[4,"Property Held for Future Use",null,null,103,0,0,{"$f":"+F286-G286","v":0}]
[5,"Utility Plant Purchased or Sold",null,null,104,0,0,{"$f":"+F287-G287","v":0}]
[6,"Construction Work in Progress",null,null,105,0,0,{"$f":"+F288-G288","v":0}]
[7,"Utility Plant Acquisition Adjustments",null,null,114,0,0,{"$f":"+F289-G289","v":0}]
[8,"Less:  Amortization of Utility Plt. Acquisition Adjust. *",null,null,115,0,0,{"$f":"+F290-G290","v":0}]
[9,"          Total Utility Plant",null,null,null,{"$f":"SUM(F285:F290)","v":0},{"$f":"SUM(G285:G290)","v":0},{"$f":"SUM(H285:H290)","v":0}]
[10]
[11,"OTHER PROPERTY AND INVESTMENTS"]
[12,"Non-Utility Property",null,null,121,0,0,{"$f":"+F294-G294","v":0}]
[13,"Less:  Accum. Depreciation & Amortization  *",null,null,122,0,0,{"$f":"+F295-G295","v":0}]
[14,"          Net Non-Utility Property",null,null,null,{"$f":"SUM(F294:F295)","v":0},{"$f":"SUM(G294:G295)","v":0},{"$f":"SUM(H294:H295)","v":0}]
[15,"Other Investments **",null,null,124,0,0,{"$f":"+F297-G297","v":0}]
[16,"          Total Other Property and Investments",null,null,null,{"$f":"SUM(F296:F297)","v":0},{"$f":"SUM(G296:G297)","v":0},{"$f":"SUM(H296:H297)","v":0}]
[17]
[18,"CURRENT AND ACCRUED ASSETS"]
[19,"Cash ",null,null,131,0,0,{"$f":"+F301-G301","v":0}]
[20,"Special Deposits",null,null,132,0,0,0]
[21,"Customer Accounts Receivable ",null,null,141,0,0,0]
[22,"Accum. Provision for Uncollectible Accounts - CR *",null,null,143,0,0,0]
[23,"Plant Material and Supplies",null,null,151,0,0,0]
[24,"Miscellaneous Current and Accrued Assets **",null,null,174,0,0,0]
[25,"          Total Current & Accrued Assets",null,null,null,{"$f":"SUM(F301:F306)","v":0},{"$f":"SUM(G301:G306)","v":0},{"$f":"SUM(H301:H306)","v":0}]
[26]
[27,"DEFERRED DEBITS"]
[28,"Miscellaneous Deferred Debits",null,null,186,0,0,{"$f":"+F310-G310","v":0}]
[29,"           Total Deferred Debit",null,null,null,{"$f":"SUM(F310:F310)","v":0},{"$f":"SUM(G310:G310)","v":0},{"$f":"SUM(H310:H310)","v":0}]
[30]
[31,"ACCUMULATED DEFERRED INCOME TAXES"]
[32,"Accumulated Deferred Income Taxes",null,null,190,0,0,{"$f":"+F314-G314","v":0}]
[33,"           Total Accumulated Deferred Incomes Taxes",null,null,null,{"$f":"SUM(F314:F314)","v":0},{"$f":"SUM(G314:G314)","v":0},{"$f":"SUM(H314:H314)","v":0}]
[34]
[35,"Total Assets & Other Debits                               (to Page 9, Line 45)",null,null,null,{"$f":"+F291+F298+F307+F311+F315","v":0},{"$f":"+G291+G298+G307+G311+G315","v":0},{"$f":"+H291+H298+H307+H311+H315","v":0}]
[null,"* Amount should be entered as NEGATIVE."]
[null,"** If over $2,000, attach detailed supporting schedule."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Docket No. 23-01003\nWater/Wastewater Combined - Class C",null,null,"Page 8 of 13",null,null,"Revised January 2023"]
[{"$f":"CONCATENATE(\"Annual Report of:    \",'Cover Pages 1-2'!$E$12)","v":"Annual Report of:    "},null,null,null,null,null,null,{"$f":"CONCATENATE(\"For the Period Ending:    December 31, \",'Cover Pages 1-2'!$H$21)","v":"For the Period Ending:    December 31, 2022"}]
["BALANCE SHEET - TOTAL COMPANY"]
["(Liabilities and Other Credits)"]
[null,"(a)",null,null,null,"(b)","(c)","(d)"]
["Line  No.","Descriptions",null,null,"NARUC Water Account Number","This Year                          $","Last Year                      $","Increase or (Decrease)"]
[null,"EQUITY CAPITAL"]
[1,"Common Stock Issued ",null,null,201,0,0,{"$f":"+F351-G351","v":0}]
[{"$f":"1+A351","v":2},"Preferred Stock Issued",null,null,204,0,0,{"$f":"+F352-G352","v":0}]
[{"$f":"1+A352","v":3},"Other Paid-In Capital ",null,null,211,0,0,{"$f":"+F353-G353","v":0}]
[4,"Retained Earnings   (Corporations ONLY)        (from Page 4, Line 36)",null,null,215,{"$f":"+F42","v":0},{"$f":"+G42","v":0},{"$f":"+H42","v":0}]
[5,"Proprietary Capital    (Proprietorships/Partnerships ONLY)",null,null,218,0,0,{"$f":"+F355-G355","v":0}]
[6,"        Total Equity Capital",null,null,null,{"$f":"SUM(F351:F355)","v":0},{"$f":"SUM(G351:G355)","v":0},{"$f":"SUM(H351:H355)","v":0}]
[7]
[8,"LONG TERM DEBT"]
[9,"Other Long-Term Debt ",null,null,224,0,0,{"$f":"+F359-G359","v":0}]
[10,"         Total Long-Term Debt ",null,null,null,{"$f":"SUM(F359:F359)","v":0},{"$f":"SUM(G359:G359)","v":0},{"$f":"SUM(H359:H359)","v":0}]
[11]
[12,"CURRENT AND ACCRUED LIABILITIES"]
[13,"Accounts Payable ",null,null,231,0,0,{"$f":"+F363-G363","v":0}]
[14,"Notes Payable  ",null,null,232,0,0,0]
[15,"Customer Deposits ",null,null,235,0,0,0]
[16,"Accrued Taxes",null,null,236,0,0,0]
[17,"Accrued Interest ",null,null,237,0,0,0]
[18,"Miscellaneous Current and Accrued Liabilities **",null,null,241,0,0,0]
[19,"        Total Current & Accrued Liabilities",null,null,null,{"$f":"SUM(F363:F368)","v":0},{"$f":"SUM(G363:G368)","v":0},{"$f":"SUM(H363:H368)","v":0}]
[20]
[21,"DEFERRED CREDITS"]
[22,"Advances for Construction ",null,null,252,0,0,{"$f":"+F372-G372","v":0}]
[23,"Other Deferred Credits ",null,null,253,0,0,{"$f":"+F373-G373","v":0}]
[24,"Accumulated Deferred Investment Tax Credits",null,null,255,0,0,{"$f":"+F374-G374","v":0}]
[25,"         Total Deferred Credits",null,null,null,{"$f":"SUM(F372:F374)","v":0},{"$f":"SUM(G372:G374)","v":0},{"$f":"SUM(H372:H374)","v":0}]
[26]
[27,"OPERATING RESERVES"]
[28,"Miscellaneous Operating Reserves **",null,null,265,0,0,{"$f":"+F378-G378","v":0}]
[29,"       Total Operating Reserves",null,null,null,{"$f":"SUM(F378:F378)","v":0},{"$f":"SUM(G378:G378)","v":0},{"$f":"SUM(H378:H378)","v":0}]
[30]
[31,"CONTRIBUTIONS IN AID OF CONSTRUCTION"]
[32,"CIAC                       (from Page 5, Line 34, Col. (b) & Line 37, Col. (b))",null,null,271,{"$f":"F112","v":0},{"$f":"F109","v":0},{"$f":"+F382-G382","v":0}]
[33,"Less:  Amort. of CIAC      (from Page 5, Line 40, Col. (b) & Line 43, Col. (b))",null,null,272,{"$f":"-F118","v":0},{"$f":"-F115","v":0},{"$f":"+F383-G383","v":0}]
[34,"        Net Contributions in Aid of Construction",null,null,null,{"$f":"SUM(F382:F383)","v":0},{"$f":"SUM(G382:G383)","v":0},{"$f":"SUM(H382:H383)","v":0}]
[35]
[36,"ACCUMULATED DEFERRED INCOME TAXES"]
[37,"Accum. Def. Income Taxes - Accelerated Depreciation",null,null,281,0,0,{"$f":"+F387-G387","v":0}]
[38,"Accum. Def. Income Taxes - Liberalized Depreciation",null,null,282,0,0,{"$f":"+F388-G388","v":0}]
[39,"Accum. Def. Income Taxes - Other",null,null,283,0,0,{"$f":"+F389-G389","v":0}]
[40,"       Total Accum. Deferred Income Taxes",null,null,null,{"$f":"SUM(F387:F389)","v":0},{"$f":"SUM(G387:G389)","v":0},{"$f":"SUM(H387:H389)","v":0}]
[41]
[42,"Total Liabilities and Other Credits                          (to Line 46)",null,null,null,{"$f":"+F356+F360+F369+F375+F379+F384+F390","v":0},{"$f":"+G356+G360+G369+G375+G379+G384+G390","v":0},{"$f":"+H356+H360+H369+H375+H379+H384+H390","v":0}]
[null,"* Amount should be entered as NEGATIVE."]
[null,"** If over $2,000, attach detailed supporting schedule."]
[]
["VERIFICATION THAT ASSETS EQUALS LIABILITIES ON BALANCE SHEET"]
[]
[43,null,null,null,null,"This Year                    $","Last Year                 $","Increase or (Decrease)"]
[44]
[45,"BALANCE SHEET - Total Assets                                         (from Page 8, Line 35)",null,null,null,{"$f":"+F317","v":0},{"$f":"+G317","v":0},{"$f":"+F400-G400","v":0}]
[46,"BALANCE SHEET - Total Liabilities                                                (from Line 42)",null,null,null,{"$f":"F392","v":0},{"$f":"G392","v":0},{"$f":"+F401-G401","v":0}]
[47,"   Difference -  MUST BE EQUAL TO ZERO!",null,null,null,{"$f":"IF(ROUND(F400,0)-ROUND(F401,0)=0,\"0\",\"ERROR\")","v":"0"},{"$f":"IF(ROUND(G400,0)-ROUND(G401,0)=0,\"0\",\"ERROR\")","v":"0"},{"$f":"IF(ROUND(H400,0)-ROUND(H401,0)=0,\"0\",\"ERROR\")","v":"0"}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Docket No. 23-01003\nWater/Wastewater Combined - Class C",null,null,"Page 9 of 13",null,null,"Revised January 2023"]
[{"$f":"CONCATENATE(\"Annual Report of:    \",'Cover Pages 1-2'!$E$12)","v":"Annual Report of:    "},null,null,null,null,null,null,{"$f":"CONCATENATE(\"For the Period Ending:    December 31, \",'Cover Pages 1-2'!$H$21)","v":"For the Period Ending:    December 31, 2022"}]
["BALANCE SHEET - SELECTED ITEMS BY DEPARTMENT"]
[null,"(a)",null,null,null,"(b)","(c)","(d)"]
["Line  No.","Descriptions",null,null,"NARUC Water Account Number","Total Company           This Year                    $","Water                This Year              $","Wastewater               This Year                            $"]
[]
[null,"UTILITY PLANT"]
[1,"Utility Plant                        (from Page 5, Line 26, Col. (c) & Col. (d))",null,null,101,{"$f":"SUM(G419:H419)","v":0},{"$f":"G98","v":0},{"$f":"H98","v":0}]
[{"$f":"1+A419","v":2},"Less:  Accum.  Depr.          (from Page 5, Line 31, Col. (c) & Col. (d))",null,null,108,{"$f":"SUM(G420:H420)","v":0},{"$f":"-G104","v":0},{"$f":"-H104","v":0}]
[{"$f":"1+A420","v":3},"          Net Utility Plant",null,null,null,{"$f":"SUM(F419:F420)","v":0},{"$f":"SUM(G419:G420)","v":0},{"$f":"SUM(H419:H420)","v":0}]
[4,"Utility Plant Leased to Others",null,null,102,{"$f":"SUM(G422:H422)","v":0},0,0]
[5,"Property Held for Future Use",null,null,103,0,0,0]
[6,"Utility Plant Purchased or Sold",null,null,104,0,0,0]
[7,"Construction Work in Progress",null,null,105,0,0,0]
[8,"Utility Plant Acquisition Adjustments",null,null,114,0,0,0]
[9,"Less:  Accum. Amort. Of Utility Plt. Acquisition Adj. *",null,null,115,0,0,0]
[10,"          Total Utility Plant",null,null,null,{"$f":"SUM(F421:F427)","v":0},{"$f":"SUM(G421:G427)","v":0},{"$f":"SUM(H421:H427)","v":0}]
[11]
[12,"OTHER ASSETS"]
[13,"Plant Material and Supplies",null,null,151,{"$f":"SUM(G431:H431)","v":0},0,0]
[14,"Accumulated Deferred Income Taxes",null,null,190,{"$f":"SUM(G432:H432)","v":0},0,0]
[15,"           Total Other Assets",null,null,null,{"$f":"SUM(F431:F432)","v":0},{"$f":"SUM(G431:G432)","v":0},{"$f":"SUM(H431:H432)","v":0}]
[16]
[17,"RATE BASE DEDUCTIONS",null,null,null," "]
[{"$f":"1+A435","v":18},"Advances for Construction *",null,null,"252/253",{"$f":"SUM(G436:H436)","v":0},0,0]
[{"$f":"1+A436","v":19},"CIAC                                   (from Page 5, Line 37, Col. (c) & Col. (d))",null,null,271,{"$f":"SUM(G437:H437)","v":0},{"$f":"-G112","v":0},{"$f":"-H112","v":0}]
[{"$f":"1+A437","v":20},"Add back: Accum. Amort.- CIAC     (from Page 5, Line 43, Col. (c) & Col. (d))",null,null,272,{"$f":"SUM(G438:H438)","v":0},{"$f":"G118","v":0},{"$f":"H118","v":0}]
[{"$f":"1+A438","v":21},"Accumulated Deferred Income Taxes *",null,null,"281/282/283",{"$f":"SUM(G439:H439)","v":0},0,0]
[{"$f":"1+A439","v":22},"TOTAL RATE BASE",null,null,null,{"$f":"F428+F433+SUM(F436:F439)","v":0},{"$f":"G428+G433+SUM(G436:G439)","v":0},{"$f":"H428+H433+SUM(H436:H439)","v":0}]
[]
[null,"* Amount should be entered as NEGATIVE."]
[]
[]
["SIMPLIFIED, UNAUDITED AND UNADJUSTED RATE OF RETURN CALCULATION"]
[]
[23,"Net Operating Income                             (from Page 4, Line 50)  ",null,null,null,{"$f":"SUM(G447:H447)","v":0},{"$f":"+G63","v":0},{"$f":"+H63","v":0}]
[24,"Rate Base                                                  (from Line 22)",null,null,null,{"$f":"SUM(G448:H448)","v":0},{"$f":"G440","v":0},{"$f":"H440","v":0}]
[25,"Rate of Return Calculation                   (Line 23 / Line 24)",null,null,null,{"$f":"IF(+F447=0,0,F447/F448)","v":0},{"$f":"IF(+G447=0,0,G447/G448)","v":0},{"$f":"IF(+H447=0,0,H447/H448)","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Docket No. 23-01003\nWater/Wastewater Combined - Class C",null,null,"Page 10 of 13",null,null,"Revised January 2023"]
[{"$f":"CONCATENATE(\"Annual Report of:    \",'Cover Pages 1-2'!$E$12)","v":"Annual Report of:    "},null,null,null,null,null,null,{"$f":"CONCATENATE(\"For the Period Ending:    December 31, \",'Cover Pages 1-2'!$H$21)","v":"For the Period Ending:    December 31, 2022"}]
[]
[]
[]
["OATH"]
[]
[]
[null,"I,",null,null,null,null,null,"on behalf of"]
[null,null,"[name of signatory]"]
[null,null,null,null,null,null,null,"declare under"]
[null,"[regulated entity]"]
[null,"penalty of perjury under the laws of the State of Nevada that I have carefully examined the foregoing information provided "]
[]
[null,"to the Public Utilities Commission of Nevada, and declare it to be a complete and correct statement to the best of my"]
[]
[null," knowledge, information and belief; and that I have the authority to make these representations and to bind the regulated"]
[]
[null," entity on whose behalf I am providing this information.  I further declare that the foregoing information has been prepared"]
[]
[null," by me or under my direction from the original books, papers and records of the regulated entity and that any accounts"]
[]
[null," and/or figures provided embrace all the relevant financial operations of the regulated entity during the period of time for "]
[]
[null,"which the information is provided."]
[]
[]
[]
[null,null,"Printed Name:"]
[]
[null,null,"Title:"]
[]
[null,null,"Date:"]
[]
[]
[]
[]
[null,null,"Signature:"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Docket No. 23-01003\nWater/Wastewater Combined - Class C",null,null,"Page 11 of 13",null,null,"Revised January 2023"]

{"sheet":"SurchargeInformation","index":4,"n_rows":68,"n_cols":7,"rows_kept":68,"cut":false,"hidden":false,"merged":[[27,0,27,6],[28,0,28,6],[2,0,2,6],[3,0,3,6],[67,0,67,6],[56,1,56,3],[57,1,57,3],[58,1,58,3],[59,1,59,3],[60,1,60,3]]}
[{"$f":"CONCATENATE(\"Annual Report of:  \",'Cover Pages 1-2'!$E$12)","v":"Annual Report of:  "},null,null,null,null,null,{"$f":"CONCATENATE(\"For the Period Ending:  December 31, \",'Cover Pages 1-2'!$H$21)","v":"For the Period Ending:  December 31, 2022"}]
[]
["System Improvement Surcharge"]
["Schedule 1"]
[]
[]
["MONTH","SURCHARGE AMOUNT","X","NO. OF CUSTOMERS","=","TOTAL BILLED","TOTAL COLLECTED"]
[]
["JANUARY",null,null,null,null,{"$f":"B9*D9","v":0}]
["FEBRUARY",null,null,null,null,{"$f":"B10*D10","v":0}]
["MARCH",null,null,null,null,0]
["APRIL",null,null,null,null,0]
["MAY",null,null,null,null,0]
["JUNE",null,null,null,null,0]
["JULY",null,null,null,null,0]
["AUGUST",null,null,null,null,0]
["SEPTEMBER",null,null,null,null,0]
["OCTOBER",null,null,null,null,0]
["NOVEMBER",null,null,null,null,0]
["DECEMBER",null,null,null,null,0]
[]
[null,null,null,null,null,"TOTAL",{"$f":"SUM(G9:G20)","v":0}]
[]
[]
[]
[{"$f":"CONCATENATE(\"Annual Report of:  \",'Cover Pages 1-2'!$E$12)","v":"Annual Report of:  "},null,null,null,null,null,{"$f":"CONCATENATE(\"For the Period Ending:  December 31, \",'Cover Pages 1-2'!$H$21)","v":"For the Period Ending:  December 31, 2022"}]
[]
["System Improvement Surcharge"]
["Schedule 2"]
[]
["SUMMARY OF SURCHARGE COLLECTION AND EXPENDITURES"]
[]
[null,null,null,"Account Balance from Previous Year"]
["DEPOSITS"]
[]
["DATE","TOTAL COLLECTED (FROM SCH 1)",null,"TOTAL DEPOSITED",null,"DIFFERENCE                   (EXPLANATION REQUIRED)"]
[]
["JANUARY",{"$f":"G9","v":0}]
["FEBRUARY",{"$f":"G10","v":0}]
["MARCH",0]
["APRIL",0]
["MAY",0]
["JUNE",0]
["JULY",0]
["AUGUST",0]
["SEPTEMBER",0]
["OCTOBER",0]
["NOVEMBER",0]
["DECEMBER",0]
[]
[null,"Total for Year",null,{"$f":"SUM(D38:D49)","v":0},null,null,{"$f":"D51","v":0}]
[]
[null,null,null,"Interest Earned This Year"]
[]
["DISBURSEMENTS - Attach additional sheets if necessary."]
[]
["DATE","DESCRIPTION",null,null,null,"TOTAL DISBURSEMENT"]
[]
[]
[]
[]
[null,null,null,"Total for Year",null,{"$f":"SUM(F58:F61)","v":0},{"$f":"-F62","v":0}]
[null,null,null,"Account Service Charge"]
[]
[null,null,null,"End of Year Account Balance",null,null,{"$f":"G33+G51+G53+G62+G63","v":0}]
[]
["INCLUDE BANK STATEMENT ENDING DECEMBER 31st - Please redact (black out) any"]
["confidential information such as bank account number, Social Security Number or Employer Identification Number in the bank statement, or file the information confidentially pursuant to the Commission's procedures in NAC 703.5274."]

{"sheet":"Data","index":5,"n_rows":40,"n_cols":2,"rows_kept":40,"cut":false,"hidden":true,"merged":[]}
[]
[]
[]
[]
[]
[]
[null,"YEAR:"]
[null,"Select Year"]
[null,2004]
[null,2005]
[null,2006]
[null,2007]
[null,2008]
[null,2009]
[null,2010]
[null,2011]
[null,2012]
[null,2013]
[null,2014]
[null,2015]
[null,2016]
[null,2017]
[null,2018]
[null,2019]
[null,2020]
[null,2021]
[null,2022]
[null,2023]
[null,2024]
[null,2025]
[null,2026]
[null,2027]
[null,2028]
[null,2029]
[null,2030]
[null,2031]
[null,2032]
[null,2033]
[null,2034]
[null,2035]